CREATE EXTERNAL TABLE spmi_dwd.dwd_ibk_increase_day_report_daily_detail_dt(
   `increase_date` date COMMENT '损益日期',             
   `belong_control_center_code` string COMMENT '所属成本中心code',  
   `belong_control_center_name` string COMMENT '所属成本中心desc',  
   `financial_center_code` string COMMENT '财务中心code',  
   `financial_center_desc` string COMMENT '财务中心desc',  
   `amount` decimal(16,2) COMMENT '发生金额',
   `product_code` string COMMENT '报表项目编码',          
   `product_name` string COMMENT '报表项目desc',        
   `profit` decimal(16,2) COMMENT '影响利润')
 COMMENT '损益报表-手工数据dwd层清洗'                          
STORED AS PARQUET
 LOCATION                                           
   'hdfs://yl-bg-hdp/dw/hive/spmi_dwd.db/external/dwd_ibk_increase_day_report_daily_detail_dt' 

